How to: Set worksheets to print with gridlines by default.
Solution:
Create a new, blank workbook and select all sheets in the workbook. Select the 'Gridlines' option in the 'Page Setup' dialog box and save the workbook in the XLSTART folder and as a template. Exit and restart Excel.
To set up all worksheets in all new workbooks to print with gridlines:
1) Create a new, blank workbook:
a) Select 'New...' from the 'File' menu. (The New dialog box appears.)
b) Select (click on) the 'Workbook' icon.
c) Click 'OK'. (A new, blank workbook appears.)
2) Select all the sheets in the new workbook.
a) Click the tab for the first worksheet.
b) Press and hold down SHIFT.
c) Click the tab for the last worksheet. (All the sheets are selected.)
3) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
4) Click 'Sheet' tab.
5) Select the 'Gridlines' check box in the 'Print' group.
the Gridlines check box
6) Click 'OK' to save the setting.
7) Save the new workbook in the XLSTART folder and as a template:
a) Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
b) Select the drive where the Microsoft Office folder is located.
c) Select the Microsoft Office folder and click 'Open'.
d) Select the Excel folder and click 'Open'.
e) Select the XLSTART folder and click 'Open'.
f) Type BOOK as the name of the workbook in the 'File name' drop-down list box.
g) Select 'Template (*.XLT)' from the 'Save as type' drop-down list.
h) Click 'Save' tosave the workbook.
8) Select the 'File' menu and select 'Exit' to close the workbook and exit Excel.
9) Restart Excel. (All new workbooks should now be set to print with gridlines.)
